﻿CREATE TABLE [EidPrayers].[Locations]
(
	LocationID int NOT NULL IDENTITY(1,1), 
	Name varchar(50) NOT NULL,
	Street varchar(100) NULL,
	Street2 varchar(100) NULL,
	City varchar(50) NULL,
	State varchar(2) NULL,
	ZipCode varchar(10) NULL,
	LongNote text NULL,
	Latitude decimal(8,6) NULL,
	Longitude decimal(8,6) NULL,
	DisplayOrder int NOT NULL
)
